<html>
<head>
<title>ShotDev.Com Tutorial</title>

  <style>
	#backg{
			margin-left: 50px;
		margin-right: 50px;
		background: #191919 url(images/img04.jpg) repeat;
	}
	#enter{
		color: yellow;
	}
	#whitecolor{
		color: white;
	}
  </style>
</head>
<body id="backg">
<form action="ass_update3.php?ID_NV=<?php echo $_GET["ID_NV"];?>" name="frmEdit" method="post">
<?php
	$objConnect = oci_connect("iss","password","orcl");
	$strSQL = "SELECT * FROM iss.NHAN_VIEN WHERE MA_NV = '".$_GET["ID_NV"]."' ";
	$objParse = oci_parse ($objConnect, $strSQL);
	oci_execute ($objParse);
	$objResult = oci_fetch_array($objParse);
	if(!$objResult)
	{
		echo "Not found MA_NV =".$_GET["ID_NV"];
	}
	else
	{
	
		?>
		<table id="enter" border="1">
		  <tr>
			<th width="91"> <div align="center">HO </div></th>
			<th width="160"> <div align="center">TEN </div></th>
			<th width="198"> <div align="center">MA_NV </div></th>
			<th width="97"> <div align="center">NGAY_SINH </div></th>
			<th width="70"> <div align="center">EMAIL </div></th>
			<th width="70"> <div align="center">MS_THUE </div></th>
			<th width="70"> <div align="center">LUONG </div></th>
			<th width="70"> <div align="center">MA_TP </div></th>
			<th width="70"> <div align="center">MA_PB </div></th>
		  </tr>
		  <tr id="whitecolor">
			<td><div align="center"><input type="text" name="txtHO" size="5" value="<?php echo $objResult["HO"];?>"></div></td>
			<td><input type="text" name="txtTEN" size="20" value="<?php echo $objResult["TEN"];?>"></td>
			<td><input type="text" name="txtMA_NV" size="20" value="<?php echo $objResult["MA_NV"];?>"></td>
			<td><div align="center"><input type="text" name="txtNGAY_SINH" size="2" value="<?php echo $objResult["NGAY_SINH"];?>"></div></td>
			<td align="right"><input type="text" name="txtEMAIL" size="5" value="<?php echo $objResult["EMAIL"];?>"></td>
			<td align="right"><input type="text" name="txtMS_THUE" size="5" value="<?php echo $objResult["MS_THUE"];?>"></td>
			<td align="right"><input type="text" name="txtLUONG" size="5" value="<?php echo $objResult["LUONG"];?>"></td>
			<td align="right"><input type="text" name="txtMA_TP" size="5" value="<?php echo $objResult["MA_TP"];?>"></td>
			<td align="right"><input type="text" name="txtMA_PB" size="5" value="<?php echo $objResult["MA_PB"];?>"></td>
		  </tr>
		  </table>
		  <input type="submit" name="submit" value="submit">
		  <?php
	}
  oci_close($objConnect);
  ?>
</form>
</body>
</html>
